package com.sky.mapper;

import com.sky.entity.AddressBook;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface AddressBookMapper {
    @Insert("insert into address_book (user_id, consignee, phone, sex, province_code, province_name, city_code, city_name, district_code, district_name, detail, label, is_default) values (#{userId}, #{consignee}, #{phone}, #{sex}, #{provinceCode}, #{provinceName}, #{cityCode}, #{cityName}, #{districtCode}, #{districtName},#{detail},#{label},#{isDefault})")
    void insert(AddressBook addressBook);
    @Select("select * from address_book where user_id=#{currentId}")
    List<AddressBook> selectByUserId(Long currentId);
    @Select("select * from address_book where user_id=#{currentId} and is_default=1")
    AddressBook selectDefault(Long currentId);

    void update(AddressBook addressBook);
    @Delete("delete from address_book where id=#{id} and user_id=#{userId}")
    void deleteById(Long id, Long userId);
    @Select("select * from address_book where id=#{id}")
    AddressBook getById(Long id);
}
